Data type considerations and exceptions

When replicating from one Amazon RDS for PostgreSQL database to a PostgreSQL-based target (e.g. Microsoft Azure Database for PostgreSQL), source and target data types are identical, with the following exceptions:

Tinterval datatype is not support on PostgreSQL version 13

Amazon RDS for PostgreSQL and PostgreSQL data type exceptions
Amazon RDS for PostgreSQL source	PostgreSQL-based target
ENUM	STRING
COMPOSITE	STRING
NUMERIC	NUMERIC (28,6)
NUMERIC (p,s) : A numeric array with precision and scale.	NUMERIC: A numeric array without precision and scale.
TINTERVAL	Information note As PostgreSQL have discontinued support for the TINTERVAL data type, tables with this data type will not be created on the target if the target database version does not support it.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here